{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DES Form","Dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DES Form","index":0,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[[34,0,34,4],[48,2,48,3],[49,2,49,3],[51,2,51,3],[52,2,52,3],[32,0,32,4],[0,0,0,4],[5,0,5,4],[13,0,13,4],[12,3,12,4],[8,3,8,4],[7,2,7,3],[15,0,16,0],[15,1,16,1],[15,3,16,3],[15,4,16,4],[17,0,17,3]]}
["DESIGN EXECUTIVE SUMMARY"]
["County:",null,"Item #:"]
["Route Number(s):",null,"State Program #:"]
["BMP/EMP:",null,"Federal Project #:"]
["Type of Work:",null,"State Project #:"]
["Highway Plan Project Description: "]
["EXISTING CONDITIONS"]
["ADT (current):",null,"Truck Class:                   ",null,"Trucks:  "]
["Existing Functional Classification:",null,"Terrain:","Route is on (check all that apply):"]
["Posted Speed Limit:            ","     mph        \"or\"       Statutory Speed Limit:"]
["Existing Bike Accommodations:",null,null,"Ped:                                              "]
["PROPOSED CONDITIONS"]
["Design Classification:",null,"Design ADT (    ):                                                                      DHV: ","Access Control:                                                                     Min. Spacing:____________"]
[]
["CONTROLLING CRITERIA:","EXISTING CONDITIONS (Estimated based upon existing geometrics.)","AASHTO Guidance (for design speed)","Recommendation","Design Exception     (check if needed for Design Speed)"]
["Design Speed ",null,"Minimum: "]
[null,null,"Selected: "]
["Note: For any remaining controlling criteria that are less than AASHTO recommended guidance: If recommended design speed is ≥ 50 mph, exceptions are needed; If recommended design speed is < 50 mph, variances are needed.",null,null,null," Exception       Variance     (≥ 50 mph)   (< 50 mph)"]
["Lane Width, No. of Lanes"]
["Shoulder Width (Minimum Usable)"]
["Horiz. Curve Radius (Minimum)"]
["Max. Superelev. Rate (emax=        %)"]
["Stopping Sight Distance (Minimum)"]
["Max. Grade (%)"]
["Normal Cross Slope (%)"]
["Vert. Clearance (ft.)"]
["OTHER CRITERIA:",null,null,null,"Design Variance"]
["Border Area (urban)"]
["Sidewalk Width, slope"]
["Bike Lane Width, slope"]
["Shared Use Path Width"]
["Other:"]
["Design Criteria Notes: "]
["Environmental Action:",null,null,"Completion Date: "]
["Existing Pavement Depths: "]
["Include:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Submitted by Project Engineer:",null,null,null,"Date:"]
["Recommended by Project Manager:",null,null,null,"Date:"]
["Tier Level Approval"]
["Location Engineer:",null,null,null,"Date:"]
["Roadway Design Branch Manager:",null,null,null,"Date:"]
["Geometric Approval Granted by:",null,null,null,"Date:"]

{"sheet":"Dropdowns","index":1,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[]
["Overview"]
["CE for Minor Projects"]
["CE Level 1"]
["CE Level 2"]
["CE Level 3"]
["EA/FONSI"]
["EIS"]
[]
[1]
[]
["Not Applicable"]
["Bowling Green"]
["Cincinnati/Northern Kentucky (OKI)"]
["Clarksville/Oak Grove"]
["Evansville/Henderson"]
["Huntington/Ashland"]
["Lexington"]
["Louisville/Southern Indiana (KIPDA)"]
["Owensboro"]
["Radcliff/Elizabethtown"]
[]
[1]
[]
[]
[]
["A","II"]
["AA","II"]
["AAA","III"]
["C"]
[1]
[]
[]
["Level"]
["Rolling",null,2]
["Mountainous",null,"By Permit"]
[null,null,"Partial"]
[1,null,"Fully Controlled"]
[]
[2]
[]
["Local"]
["Collector"]
["Arterial"]
["Interstate"]
[]
[1]
[]
[]
["None"]
["Shared Lane"]
["Bike Lane"]
["Shoulder"]
["Designated Bike Route"]
["Bike Path"]
["Shared Used Path"]
[2,1]
[]
[]
["Aerial"]
["Lidar"]
["Conventional"]
[]
[]
["600 ft"]
["1200 ft"]
[]
[1]
[]
[]
["Location Engineer"]
["Rdwy. Design Br. Mgr. "]
["Director, Div. of Hwy. Design"]
[]
[1]
[]
[]
[]
[2]
[]
["Local"]
["Collector"]
["Arterial"]
["Interstate"]
[]
[1]